﻿CREATE TABLE [dbo].[ScheduleMaster_Tbl] (
    [MasterID]       INT            IDENTITY (1, 1) NOT NULL,
    [OrderID]        INT            NULL,
    [LineItem]       INT            NULL,
    [MultipleNo]     INT            NOT NULL,
    [LocaleID]       INT            NULL,
    [DepartmentID]   INT            NULL,
    [Value]          FLOAT          NULL,
    [DeliveryWeek]   INT            NULL,
    [ProdStartWeek]  INT            NULL,
    [ProdStartYear]  INT            NULL,
    [OrderDate]      NVARCHAR (50)  NULL,
    [TotalCalcHrs]   FLOAT          NULL,
    [Cutter]         INT            NULL,
    [Mould]          INT            NULL,
    [ProjectWeeks]   INT            NULL,
    [InputArea]      FLOAT          NULL,
    [Fixed]          BIT            NOT NULL,
    [GenBoatID]      INT            NULL,
    [CustomerID]     INT            NULL,
    [Salesman]       NVARCHAR (50)  NULL,
    [BoatType]       NVARCHAR (MAX) NULL,
    [CostSailTypeID] INT            NULL,
    [TierID]         INT            NULL,
    [UsageTypeID]    INT            NULL,
    [GenSailTypeID]  INT            NULL,
    [DesignFile]     NVARCHAR (50)  NULL,
    [WorkProgressID] INT            NOT NULL,
    [MarketID]       INT            NULL
);

